﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="MasterFiche.aspx.vb" Inherits="MasterFiche" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Liste des fiches médicales disponibles votre serveur.</title>
</head>
<body style="font-size: 12pt">
    <form id="form1" runat="server">
    <div>
        <table id="TABLEMEP" width="100%">
            <tr>
                <td align="center" bgcolor="#ffcc33" colspan="3" valign="middle">
                    <span style="font-size: 14pt; color: #ffffff; font-family: Arial">Liste des messages
                        disponibles sur Res@Core</span></td>
            </tr>
            <tr>
                <td align="center" colspan="3" valign="middle">
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" CellPadding="4" DataKeyNames="id_message" DataSourceID="SqlDataSource1"
                        EmptyDataText="Il n'y a aucun enregistrement de données à afficher." Font-Size="X-Small"
                        ForeColor="#333333" GridLines="None" Width="100%">
                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <Columns>
                            <asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" />
                            <asp:BoundField DataField="id_message" HeaderText="id_message" ReadOnly="True" SortExpression="id_message" />
                            <asp:BoundField DataField="id_resamu" HeaderText="id_resamu" SortExpression="id_resamu" />
                            <asp:BoundField DataField="id_equipe" HeaderText="id_equipe" SortExpression="id_equipe" />
                            <asp:BoundField DataField="type_message" HeaderText="type_message" SortExpression="type_message" />
                            <asp:BoundField DataField="ref_message" HeaderText="ref_message" SortExpression="ref_message" />
                        </Columns>
                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                        <EditRowStyle BackColor="#999999" />
                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ResaMessageConnectionString %>"
                        DeleteCommand="DELETE FROM [Ecoute] WHERE [id_message] = @id_message" InsertCommand="INSERT INTO [Ecoute] ([id_message], [id_resamu], [id_equipe], [type_message], [ref_message]) VALUES (@id_message, @id_resamu, @id_equipe, @type_message, @ref_message)"
                        ProviderName="<%$ ConnectionStrings:ResaMessageConnectionString.ProviderName %>"
                        SelectCommand="SELECT [id_message], [id_resamu], [id_equipe], [type_message], [ref_message] FROM [Ecoute]"
                        UpdateCommand="UPDATE [Ecoute] SET [id_resamu] = @id_resamu, [id_equipe] = @id_equipe, [type_message] = @type_message, [ref_message] = @ref_message WHERE [id_message] = @id_message">
                        <InsertParameters>
                            <asp:Parameter Name="id_message" Type="String" />
                            <asp:Parameter Name="id_resamu" Type="String" />
                            <asp:Parameter Name="id_equipe" Type="String" />
                            <asp:Parameter Name="type_message" Type="String" />
                            <asp:Parameter Name="ref_message" Type="String" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="id_resamu" Type="String" />
                            <asp:Parameter Name="id_equipe" Type="String" />
                            <asp:Parameter Name="type_message" Type="String" />
                            <asp:Parameter Name="ref_message" Type="String" />
                            <asp:Parameter Name="id_message" Type="String" />
                        </UpdateParameters>
                        <DeleteParameters>
                            <asp:Parameter Name="id_message" Type="String" />
                        </DeleteParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td colspan="3">
                </td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>
